{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Instructions","Form","Distribution List P&L","Distribution List CG"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":3,"defined_names":7,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Instructions","index":0,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Instructions for No Surprise Partnership Communication:"]
[]
["1)","The initiator of each communication using this form must verify the distribution list and make the necessary corrections to ensure"]
[null,"the distribution is correct."]
["2)","Use this form for both Quality and Materials communications."]
["3) ","Retain evidence of customer notification and acknowledgement for all issues that impact the customer."]

{"sheet":"Form","index":1,"n_rows":92,"n_cols":29,"rows_kept":92,"cut":false,"hidden":false,"merged":[[46,0,46,1],[2,0,2,1],[2,2,2,4],[2,5,2,7],[2,8,2,12],[4,0,4,1],[4,2,4,4],[4,5,4,7],[4,8,4,12],[46,2,46,4],[46,6,46,13],[6,0,6,1],[6,2,6,4],[6,5,6,7],[6,8,6,12],[9,0,9,13],[21,0,21,13],[7,0,7,1],[8,6,8,7],[22,0,25,13],[27,0,27,13],[28,0,28,13],[29,0,29,13],[30,0,31,4],[30,5,31,7],[30,8,30,13],[31,8,31,10],[31,11,31,13],[26,0,26,13],[34,0,34,4],[34,5,34,7],[34,8,34,10],[34,11,34,13],[35,4,35,5],[35,6,35,7],[35,0,36,3],[35,8,35,9],[35,11,35,13],[36,8,36,9],[36,4,36,5],[32,0,32,4],[32,5,32,7],[32,8,32,10],[32,11,32,13],[33,0,33,4],[33,5,33,7],[33,8,33,10],[33,11,33,13],[36,6,36,7],[36,11,36,13],[35,10,36,10],[52,20,53,21],[53,14,53,19],[55,0,55,13],[42,0,42,1],[42,2,42,4],[42,5,42,6],[42,8,42,13],[43,2,43,4],[40,0,40,1],[40,2,40,4],[40,5,40,6],[40,8,40,13],[41,0,41,1],[41,2,41,4],[41,5,41,6],[41,8,41,13],[47,2,47,4],[48,2,48,4],[49,2,49,4],[50,2,50,4],[51,2,51,4],[50,6,50,13],[51,6,51,13],[49,6,49,13],[43,5,43,7],[59,0,59,7],[59,9,59,13],[60,2,60,3],[60,5,60,6],[60,8,60,11],[60,12,60,13],[52,0,53,1],[52,4,53,5],[44,5,44,7],[52,14,52,19],[58,0,58,13],[56,2,56,4],[56,8,56,12],[54,0,54,13],[72,0,72,1],[68,8,68,11],[69,2,69,3],[69,8,69,11],[65,2,65,3],[73,0,73,1],[76,0,76,1],[61,14,69,14],[62,2,62,3],[62,8,62,11],[63,2,63,3],[63,8,63,11],[64,2,64,3],[64,8,64,11],[68,2,68,3],[65,8,65,11],[66,2,66,3],[66,8,66,11],[67,2,67,3],[67,8,67,11],[61,2,61,3],[61,8,61,11],[61,12,61,13],[71,14,83,14],[80,5,80,7],[74,8,74,11],[75,2,75,3],[75,8,75,11],[76,2,76,3],[76,8,76,11],[77,8,77,11],[71,2,71,3],[74,0,74,1],[74,2,74,3],[74,5,74,7],[75,0,75,1],[77,0,77,1],[77,2,77,3],[78,0,78,1],[78,2,78,3],[78,5,78,7],[78,8,78,11],[79,0,79,1],[79,2,79,3],[79,8,79,11],[71,5,71,7],[71,8,71,11],[81,0,81,1],[81,2,81,3],[81,5,81,7],[81,8,81,11],[72,2,72,3],[72,5,72,7],[72,8,72,11],[73,2,73,3],[80,0,80,1],[80,2,80,3],[81,12,81,13],[82,0,82,1],[82,2,82,3],[82,5,82,7],[82,8,82,11],[82,12,82,13],[88,5,88,7],[88,8,88,11],[88,12,88,13],[73,8,73,11],[78,12,78,13],[80,8,80,11],[80,12,80,13],[79,12,79,13],[85,5,85,7],[85,8,85,11],[85,12,85,13],[83,0,83,1],[83,2,83,3],[83,5,83,7],[83,8,83,11],[83,12,83,13],[99,5,99,8],[99,10,99,13],[95,10,95,14],[89,0,89,1],[89,2,89,3],[84,0,84,1],[84,2,84,3],[84,8,84,11],[84,12,84,13],[85,0,85,1],[97,10,97,13],[98,5,98,8],[98,10,98,13],[86,12,86,13],[87,0,87,1],[87,2,87,3],[87,5,87,7],[87,8,87,11],[91,12,91,13],[88,2,88,3],[85,14,91,14],[86,0,86,1],[86,2,86,3],[86,5,86,7],[86,8,86,11],[102,6,102,8],[102,10,102,13],[96,5,96,8],[96,10,96,13],[97,5,97,8],[91,0,91,1],[91,2,91,3],[91,5,91,7],[91,8,91,11],[89,5,89,7],[89,8,89,11],[90,0,90,1],[90,2,90,3],[39,0,39,1],[39,2,39,4],[39,5,39,13],[88,0,88,1],[90,5,90,7],[90,8,90,11],[90,12,90,13],[87,12,87,13],[89,12,89,13],[85,2,85,3],[37,0,37,3],[37,4,37,7],[37,8,37,13],[38,0,38,3],[38,4,38,7],[38,8,38,13]],"flags":["formulas_cached_only"]}
[null,null,null,"No Surprise Partnership Communication"]
[]
["Date:",{"$nulls":4},"Contact Name:"]
[]
["Customer:",{"$nulls":4},"Phone #:",{"$nulls":22},"CG EU - CBU VW"]
[]
["Ship To:",{"$nulls":4}," Adient Facility:"]
["Program Name:",{"$nulls":6},"Response Required:"]
[{"$nulls":6},"(who and when)"]
["Issue:  Tracking Number (if applicable) _______________"]
[]
[null,null," Personal safety & injuries",null,null,null," Customer Quality"]
[]
[null,null," Capacity Constraints",null,null,null," Supplier Quality"]
[null,null," ",null,null,null," "]
[null,null," Balance Out",null,null,null," Line Interruptions"]
[]
[null,null," Demand Variance",null,null,null," Pilot / Launch"]
[]
[null,null," Leadtime Violation",null,null,null," Other _________________________________________"]
[{"$nulls":5},0]
["Issue Description: (attach pictures if req)"]
[]
[]
[]
[]
["Suspected Root Cause(s)"]
["1)"]
["2)"]
["3)"]
["Corrective Actions: (add attachments for additional space)",{"$nulls":4},"Responsibility",null,null,"Timing"]
[{"$nulls":8},"Plan",null,null,"Actual"]
[]
[]
[]
["Ship Window Affected:",null,null,null,"Est. Date",null,"Est. Time",null,"Actual Date",null,null,"Actual Time"]
[]
["Beginning Sequence Number",null,null,null,"Ending Seq",null,null,null,"Variance"]
[]
["Cost Impact",null,"Description",null,null,"Timeline"]
["Supplier Overtime / Setup Charge:",{"$nulls":4},"Review Date:"]
["Adient Overtime:",{"$nulls":4},"Est Close Date"]
["Premium Freight",{"$nulls":4},"Actual Close Date"]
["Other:",{"$nulls":4},"Actual Cost of Premium Freight:"]
["Total Cost:","$",null,null,null,"Payor of Premium Freight:"]
[]
["Escalation of No Surprise:",null,"Scope of Issue",null,null,null,"Minimum Distribution"]
[null,null,"Miss Ship to Customer",null,null,null,"All"]
[null,null,"Issue within plant-no customer impact",null,null,null,"Plant only"]
[null,null,"Alert Supplier of Demand Charges",null,null,null,"Plant Materials and Effected Supplier"]
[null,null,"Adient to Adient Demand Variation Communication ",null,null,null,"Plant and SCE"]
[null,null,"Premium Cost to Meet Demand",null,null,null,"All"]
["Distribute to Customer (X)",null,"Yes",null,"Distribute to other Plants (X)",null,"<Enter plant>",null,"<Enter plant>",null,"<Enter plant>",null,"<Enter plant>"]
[null,null,"No",null,null,null,"<Enter plant>",null,"<Enter plant>",null,"<Enter plant>",null,"<Enter plant>"]
["Retain evidence of customer notification and acknowledgement for all issues that impact the customer."]
["Approvals"]
["Plant Manager",{"$nulls":5},"Quality Manager"]
[]
["Distribution list"]
["Group Level\n(Add or Delete According To Issue)",{"$nulls":7},"P&L:","< SELECT >"]
["Group Level","Out","Email",null,"Telephone","P&L Level",null,"Out","Email",null,null,null,"Telephone"]
["Group VP Quality",null,"",null,null,"Group VP (P&L leader)",null,null,"",{"$nulls":5},"Filled automatically when selecting P&L"]
["Group VP Strategic Planning",null,"",null,null,"Group VP (P&L leader II)",null,null,""]
["Group VP Program Mgmt",null,"",null,null,"VP Operations",null,null,""]
["VP Product Safety Global",{"$nulls":4},"VP/Director Quality",null,null,""]
["VP Supplier Quality Global",null,"",null,null,"VP Program Mgmt",null,null,""]
["other",null,"",null,null,"Director  Safety",null,null,""]
["Other",{"$nulls":4},"Director Quality OPS",null,null,""]
["Other",{"$nulls":4},"Director Supplier Quality",null,null,""]
["Other",null,"",null,null,"Director Central Quality",null,null,""]
[]
["CBU Level",null,"< SELECT >",null,null,"Issuing Plant Level",{"$nulls":8},"Filled automatically when selecting CBU\n\nPlant Level has to filled manual"]
["VP & GM CBU",null,"",null,null,"Managing Director"]
["Dir./Mgr. Quality",null,"",null,null,"Operations Manager"]
["Director MQE",null,"",null,null,"Quality Manager"]
["Director AQE",null,"",null,null,"Materials Manager"]
["Director Purchasing",null,"",null,null,"Plant Controller"]
["other",null,"",null,null,"Program Manager"]
["other",null,"",null,null,"Launch Manager"]
["other",null,"",null,null,"Mfg. Eng. Manager"]
["other",null,"",null,null,"SCM Engineer"]
[{"$nulls":5},"Other"]
[{"$nulls":5},"Other"]
[{"$nulls":5},"Other"]
[]
["Customer Plant (if applicable)",{"$nulls":4},"Supplier (if applicable)",{"$nulls":8},"To be filled by plant if applicable"]
["OSS Manager",{"$nulls":4},"General Manager"]
["Operations Manager",{"$nulls":4},"Customer Service Rep"]
["Quality Manager",{"$nulls":4},"Program Manager"]
["Materials Manager",{"$nulls":4},"Sales Representative"]
["Purchasing Manager",{"$nulls":4},"Materials Manager"]
["Other",{"$nulls":4},"Other"]

{"sheet":"Distribution List P&L","index":2,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"< SELECT >","Complete Seats - Americas","Complete Seats - EU","Complete Seats - AP","PBU Foam - Americas","PBU Foam - EU","PBU Metals - Americas","PBU Metals - EU","PBU Trim - Americas","PBU Trim - EU","PG Electronics","PG Interiors - Americas","PG Interiors - EU","China"]
["Group VP (P&L leader)",null,"Jeff.Williams@jci.com","Bryan.Gray@jci.com","Randal.P.Leslie@jci.com",{"$nulls":6},"Paul.Lambert@jci.com","Jeffrey.A.DeBest@jci.com","Jeffrey.A.DeBest@jci.com","Johannes.Roters@jci.com"]
["Group VP (P&L leader II)",{"$nulls":4},"Brian.W.Cooke@jci.com","Brian.W.Cooke@jci.com","Byron.S.Foster@jci.com","Manfred.Rotterdam@jci.com"]
["VP Operations",null,"Jesus.Beas@jci.com","Wolfgang.Merkel@jci.com","Michael.D.Summers@jci.com","Thomas.W.Bobo@jci.com","John.Moulton@jci.com",null,null,"Jef.Vercammen@jci.com","Jef.Vercammen@jci.com","Philippe.Simon@jci.com","Terry2.Campbell@jci.com","Alan.C.Mumby@jci.com","Neil.Morrison@jci.com"]
["VP/Director Quality",null,"David.Mihelick@jci.com","Wolfgang.Merkel@jci.com","Alan.J.Selbert@jci.com",null,null,"tbd","tbd","Owen.J.Weir@jci.com","Owen.J.Weir@jci.com",null,"Robert.F.DePotter@jci.com","Robert.F.DePotter@jci.com","Su.Zhe@jci.com"]
["VP Program Mgmt",null,"Richard.E.Pence@jci.com","Eamonn.Kearney@jci.com","Yasuji.Ikisu@jci.com","Marc.De-Winter@jci.com ","Marc.De-Winter@jci.com ",null,"Luc.G.Lagasse@jci.com",null,"denis.pignede@jci.com","Caryl.Brown@jci.com",null,"Matthias.Koeppe@jci.com","Fang.Chau.Chang@jci.com"]
["Director  Safety",null,null,"Bernd.Kraemer@jci.com","Hiroki.Nagai@jci.com"]
["Director Quality OPS",null,null,"Georgi.Tschumboridse@jci.com"]
["Director Supplier Quality",null,"tbd","Michael.Klagge@jci.com","tbd","tbd","tbd","tbd","tbd","tbd","tbd","tbd","tbd","tbd","tbd"]
["Director Central Quality",null,"Regina.K.Locklear@jci.com","Heike.Braeunlich@jci.com",null,"Darrell.J.Robertson@jci.com","Hans-Peter.Thellmann@jci.com","tbd","tbd","Sam.Gutierrez@jci.com","Roman.Stepanek@jci.com","Philippe.Reverdy@jci.com",null,"Arndt.Vukan@jci.com","Karen.Yang@jci.com"]

{"sheet":"Distribution List CG","index":3,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"< SELECT >","CG EU - CBU Daimler/BMW","CG EU - CBU Fiat","CG EU - CBU Renault/PSA","CG EU - CBU VW","CG EU - Volvo ","CG EU - Region Russia","CG EU - Region South Africa","CG NA - CBU Chrysler","CG NA - CBU Ford","CG NA - CBU GM","CG AP- CBU Honda","CG AP- CBU Hyundai/KIA","CG AP- CBU JLR","CG AP- CBU Nissan","CG AP- CBU Toyota"]
["VP & GM CBU",null,"Matthias.Berg@jci.com","Marzio.Raveggi@jci.com","Yves.Marchal@jci.com","Detlef.Juers@jci.com","Stefan.Hagerstroem@jci.com","Heinrich.Fiedler@jci.com","Ingo.Fleischer@jci.com","Michael.T.Muncie@jci.com","Randal.P.Leslie@jci.com \n","Jim.A.Bennethum@jci.com","Yoshiharu.Kittaka@jci.com","Sung.Min.Lee@jci.com \n","Paul.Chawla@jci.com","Yasushi.Inoshita@jci.com","Christopher.E.Couch@jci.com"]
["Dir./Mgr. Quality",null,"Martin.Klimpel@jci.com","Roberto.Arosio@jci.com","Trevor.Pillay@jci.com","Monika.Malisova@jci.com","Hans.Rossle@jci.com","Alexander.Beierbach@jci.com","Allan.Venter@jci.com","Michael.Beck@jci.com","James.W.Smalley@jci.com","James.Pastor@jci.com","Masayuki.Nakamura@jci.com","tbd",null,"Akihiro.Makino@jci.com","tbd"]
["Director MQE",null,"na",null,null,"na"]
["Director AQE",null,"na",null,null,"na"]
["Director Purchasing"]
["other"]
["other"]
["other"]
["other"]